﻿CREATE TABLE [dbo].[Department] (
    [Id]       VARCHAR (32)  NOT NULL,
    [Name]     NVARCHAR (50) NOT NULL,
    [ParentId] VARCHAR (32)  NULL,
    [Path]     VARCHAR (320) NULL,
    [Sort] INT NOT NULL DEFAULT 0, 
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

